Skip to main content

DATE

Returns the serial number of a particular date.

Syntax​

DATE(year, month, day)

Arguments​

  • year: The year component of the date.
  • month: The month component of the date (1-12).
  • day: The day component of the date (1-31).

Example​

DATE(2025, 3, 2) → Returns the date value for March 2, 2025
DATE(A1, B1, C1) → Returns a date using the year in A1, month in B1, and day in C1